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!

Rename field values and export to a list

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.