Rename field values and export to a list

[ulysses_no]

Hi!

In order to reduce the size and performance of the CSV file exported from Alteryx I have thought of a solution:

- Rename values to short dummy values, export these values to a list, and make a link of these into MS Power BI.

• For example:
  • The Column "Brand", renames every value to B1, B2, B3, B4, and so on.
  • Then have Alteryx export a list where B1 = Apple, B2 = Microsoft, B3 = Fitbit, B4 = Google, and so on.
  • Then I can import the list in Power BI and make a relationship between these two.

This reduces the amount of text, and thus the size and performance of the CSV file. 

I am however in the dark of HOW I'm gonna achieve this in Alteryx 🙂 

Any good helpers here? Thanks in advance!

[atcodedog05]

Hi @ulysses_no 

Can you provide sample data we can help you out.

[ulysses_no]

Hi @atcodedog05 
Thanks for reaching out, attached is a dummy CSV file with different columns with values that I want to be renamed and exported

[atcodedog05 · Accepted solution]

Hi @ulysses_no 

Here is how you can do it.

Workflow:

1. Using summarize to get list of brand.

2. Using record id to get Brand unique ID

3. Using formula to create Brand ID "B1"...

4. Using find and replace to replace brand with Brand ID

5. After select tool exporting the brand id.

Hope this helps : )

Hope this helps : )

[ulysses_no]

Thank you so much, @atcodedog05 ! It was just what I was looking for! 🙂 

[atcodedog05]

Happy to help : ) @ulysses_no 

Cheers and have a nice day!