New column adding

[Sultanbek]

I have a case where we should import data from Intacct to Anaplan via Workato. However to do so, firstly we need to create an Unique UID in exporting data of Intacct through Workato. I know that workato has two formulas to generate such UID (UUID and .encode_base64). However I dont understand how I should use these formulas in order to update the export data from Intacct. 

For example:

Intacct has the following transactions: 

1. Column 1 - Date
2. Column 2 - Amount
3. Column 3 - GL Account

We need to create action to import this data to Anaplan on monthly basis since it will be updated every month.

Now we need to create a new column called "UID". Consequently the data from Intacct should look like:

1. Column 1 - Date
2. Column 2 - Amount
3. Column 3 - GL Account
4. Column 4 - UID

According to the above, does anyone have an idea how it should be built in workato to create UID and add it as a new column in raw data?

#UUID #UID #Anaplan #Workato