Join datasets with no common fields

Hi, I have two datasets and they do not have any common fields. Is there a way I could join them?

File #1 - lists all the customers with their personal details

File #2 - information about the group of customers

The purpose of the flow is to clean/format the data in File #1 to load into our system.

I want to add a feature that will automatically assign identification numbers IF a certain field is populated in File #2.

Developer

Accepted answers

echuong1

Do you have some sample data you're able to share?

I'm not sure how helpful it'll be to join the two datasets together if there is no common information, but you can use the Join tool with Join by Record Position to essentially place the two datasets next to each other.

All comments

echuong1

Do you have some sample data you're able to share?

wwatson

I would suggest you will need to create a join field in both input sources based on your IF statement.

Can you provide a small sample of the 2 inputs with the logic you want to use?

reginawhelan

Thank you! I used the 'Join by Record Position' and received the desired results.

I am now struggling with the If statements. After the join:

- added an If Statement to check and see if an Identifier/Record ID should be assigned - works great. Was dependent on the info in File #2. New column (Assign Cert # ) "if isempty([SD System Generated ID]) then null() elseif [SD System Generated ID] = "System Generated" then "Yes" else "No" endif"

- added a record ID function

- another If statement in a Formula function "if [Assign Cert # ] = "Yes" then [RecordID] else [F4] endif"

I want the record ID to appear in column [F4] if [Assign Cert # ] is "Yes"

it is not working. Do you know what I could be doing wrong?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703