Completing table using values coming from a second table and common references.

[julianveda]

Hi community,

I have a hard time trying to put the information in column "F3" from the first table in the same column "F3" of the second table. There is a column in both tables that could be used as common key. The ides as you can see in the image is respect all the other cells in table two, just to put those missing values from table 1 into the table 2:

Thanks for reading

[binuacs]

@julianveda One way of doing this with the Find and Replace tool

[ShankerV]

Hi @julianveda 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @julianveda 

Step 1: Input 1

Step 2: Input 2

Step 3:

IF IsNull([F3])
THEN [Instruction]
ELSE [F3]
ENDIF

Step 4:

Many thanks

Shanker V

[julianveda]

Hi,

Thank you for yoir answer. I have a small question: why put "!IsEmpty([Instructions])" in the formula tool ?

I used a formula tool (not visible in the image) this time taking out "!IsEmpty([Instructions])" and it also worked

[julianveda]

@ShankerV ,

Thank you for your answer. Unfortunately, when I tried to reproduce it, I did not get a good result. Please see the picture below and you'll see that the three names with the red flag  do not correspond to the original names (Nmae 26, Name 27, Name 28). As you can notice, a part of the name has been left out.

[binuacs]

@julianveda If you look at the instruction fields there are NULL values, the isEmpty() function can check for NULL as well as Blank values, If the Instruction field is NULL then I don't want to write anything on that row, that is why I put !isEmpty([instruction]), in this case the formula will only consider if the instruction field has some value and leave the NULL rows as it is

[binuacs]

@julianveda You need to increase the size of the field F3 using a select tool

[julianveda]

Thank you @binuacs . I would like to ask you a final question about this situation:

Do you know how to make things more dynamically ? I mean, the column created after the replace tool ("F5") will change name depending on the number of columns I have in my file. I did a test on my original data and this created field that had the name "F9_2" automatically created by Alteryx. In this case I would need to come back to the flow and modify it putting [F9_2] istead of [F5] in the replace tool. I would prefer something more dynamically. Do you knos if is there anyway to do this?

[ShankerV]

Hi @julianveda 

When you have replicated my workflow as it has only Name because of the Field length.

Use select tool to increase the size of the column. It will resolve the issue.

Many thanks

Shanker V