I have data set with 2 columns ( region, format ) and a data set with 2 columns ( region, amount). How do I format amount column by the region ?

[41ee87c18453c9a5911f]

I have 2 data sets :

+ a data set has 2 columns ( region / format ) such as (US/"0.00", VN/"0")

+ a data set has 2 columns ( region / amount ) such as (US/10,5, VN/1000)

How do I format "amount" column by the region with "lookup" and "numformat" functions?

The expected result is (US/10.50, VN/1000).

[TrifactaUsers]

Hi,

If you are going to store integer and float in the same field, then the field final format should be float else float values will be invalid and ignored in the result set.

[Trifacta_Alumni · Accepted solution]

Hi Kiet,

Unfortunately there isn't a way today to pass a column's value dynamically in to the NUMFORMAT function as the format (though this is a great idea and something we've added to the backlog). For now you'll need to use the IF function or 'Conditional column' transform and define each format type you're looking to output to. You can then map each country to one of those output format types. This could look something like:

Hope this helps!

[41ee87c18453c9a5911f]

How can I use the IF function with variety data (US, VN, JP, CN, etc.) ?