topic Re: New column adding in Workato Pros Discussion Board

New column adding

Sultanbek — Tue, 06 Feb 2024 15:51:08 GMT

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:

Column 1 - Date
Column 2 - Amount
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:

Column 1 - Date
Column 2 - Amount
Column 3 - GL Account
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

Re: New column adding

wayswssb — Tue, 29 Oct 2024 07:07:15 GMT

I met same issue, does anybody know how to handle this in Workato? Thanks.

Re: New column adding

shivakumara — Tue, 29 Oct 2024 13:52:52 GMT

Hi @Sultanbek
Here is the solution:
1. Use "workato.uuid.encode_base64" to generate random UID and encode)

2. Map Data to Anaplan:

- When creating the action to send the data to Anaplan, ensure that the following columns are mapped:

- Date

- Amount

- GL Account

- UID (generated using the formula step_1)

3. Transform the Data in Workato:

- In the Export Data step from Intacct, use a Data Mapper to add a new field called UID(Step_1) and assign it the above formula.

- This will append a unique UID to every transaction row dynamically before it gets imported into Anaplan.

Could you please try it from your end and let me know if this works, unfortunately I don't have active connection to try it out.

Thanks and Regards,
Shivakumara A

Re: New column adding

ndy — Tue, 29 Oct 2024 14:11:24 GMT

Dear @Sultanbek , @wayswssb.

To create a unique UID for each row in your Intacct data export within Workato, you can follow these steps:
1. Generate a Unique ID: Use random_bytes(16).encode_base64 to generate a 16-byte random string and encode it in Base64. This will give you a unique string each time it’s generated.

random_bytes(16).encode_base64

2. Combine with Existing Fields (Optional):
- If you want the UID to be derived from specific fields, combine columns like Date, Amount, and GL Account. For example:

([Date] + [Amount] + [GL Account]).encode_base64

- .encode_base64 will convert the combined string into a unique base64-encoded identifier.
3. Add UID to Each Row:
- Use the Workato formula to create the UID and add it as a new column in your data. You can add this UID in a `Create row` or `Update row` action for Anaplan.
Let me know if you'd like more details on the setup in Workato!