JOIN DATA BY USER SELECTION FIELDS

[Terrymax]

HI All

i am trying to : 

1 . build an APP to allow user import their own data 

2. allow user to select the key field for join data

3. by using the key field , join to antoher master list

4. get the result. 

As below pictures show, the user selected fields are unable to pass to the join tools. 

Anyone can help? or share some kind of such APP to me ? 

Thanks very much!

[atcodedog05 · Accepted solution]

Hi @Terrymax 

1. Do you know why the "list values" is disabled from my end?

List values is disabled because field list from previous tool which is connected to Q is taken as list values.

2. How can i change the data type as string for all for user selected fileds? 

Unfortunately, there is no easy way to change datatype of only the selected fields.

What you can do is change datatype of all fields to v_string perform join then use autofield to convert them to proper datatypes. It would be something like below.

Hope this helps : )