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!

A3 Auto Map list.yxwz

Apps

Accepted answers

atcodedog05

Hi @Terrymax

Sadly column name options are not dynamic in a single App.

You can achieve using chained app.

1st app: Saves user file data and column name data into files.

2nd app: In this app, load the column name options from the file which was outputted in previous app and proceed forward.

Output:

Hope this helps : )

A3 Auto Map list - First.yxzp

MatthewBr

1. Here is a link to a bunch of video content on the community:

Video Training Index - Alteryx Community

2. My guess is you will need a select in your workflow to convert the "ID" fields in question to be in the same format (string)

atcodedog05

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 : )

A3 Auto Map list - First.yxzp

All comments

atcodedog05

Hi @Terrymax

Can you please provide the associated input files of the worfklow.

Terrymax

Please find two files:

By using the LE ID to join the master list

MASTER LIST.xlsx

user input.xlsx

atcodedog05

Hi @Terrymax

You can setup workflow like below for your usecase.

Workflow:

Hope this helps : )

A3 Auto Map list.yxwz

MatthewBr

Something similar.

Please remember to mark as complete if your answer has been met! Nice job community!

Analytic App - Update Join Tool.yxwz

atcodedog05

Hi @Terrymax

Sadly column name options are not dynamic in a single App.

You can achieve using chained app.

1st app: Saves user file data and column name data into files.

2nd app: In this app, load the column name options from the file which was outputted in previous app and proceed forward.

Output:

Hope this helps : )

A3 Auto Map list - First.yxzp

MatthewBr

1. Here is a link to a bunch of video content on the community:

Video Training Index - Alteryx Community

2. My guess is you will need a select in your workflow to convert the "ID" fields in question to be in the same format (string)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703