Conditional statements between multiple columns and documents

[jalizmaldonado]

Hi, I hope all is well. 

I'm looking to create a conditional statement between separate files and separate columns (my current attempt is very messy with additional data columns and it's just not working...).

Document 1 - Contains two columns where we want to pull information from:

[Description]

[Current Amt.]

Document 2 - Consolidated template file where the total sum of current amounts is correlated to each description. 

[Description]

[Total Amount]

I appreciate your assistance.

[randreag]

hello @jalizmaldonado 

I think is not very clear what are you trying to accomplish

You have two files and you need to make a conditional that takes both files, rigth? Do you have a key to join them?

Can you put an example of the data?

Or maybe explain better the problem you are having