Help

[ramarora1985]

Hello Experts,

I am pretty new to Alteryx and was trying some weekly challenges for beginners. I got struck with WEEKLY CHALLENGE# 35 where I am unable to understand the formula. Can anybody help me in understanding this formula and how we derive this.

Challenge file and response file of the of the experts has been attached.

Many thanks !

Regards

[atcodedog05 · Accepted solution]

Hi @ramarora1985 ,

The challenge is pretty straight forward

The data has a column [Region Key] which is region ID and [Product Key] which is product ID

The requirement is to generate separate file for each Region - Product. Hence below formula is used.

"Region"+tostring([Region Key])+"_"+"Product"+tostring([Product Key])

Output : Region1_Product1 (So on)

Here is tostring convert any datatype to string (Here Region_Key and Product_key). "Region" and "Product" is just used for display.

At the end configuration in output tool has been selected as below to create separate files for each unique value in the column Output_Name.

Hope this helps. Please let me know if you have any more concern.