Forum Discussion
Advocate IMerge query based on 2 variables
Hi guys,
I'm trying to get information from 1 table lined up to another table.
One table shows all transactions we have in our business. The other is a manual sheet that has collected issues that occured.
The columns I have to match, iare the mobile number of a user and the date on which it happened.
I'd like to merge the information of the issue to the transaction table, if I find a match of phone number and date at the same time.
Is there a good way to do this?
Your help is super appreciated!
Yes, You can concatenate both the column "Mobile no and Date" and go ahead.
3 Replies
- ddpl
Solution Sage
Yes, You can concatenate both the column "Mobile no and Date" and go ahead.
jeroenwmwillemsUnfortunately I struggled combining the columns as text and date did not go together. Even after converting both to text, my data had some entries that weren't in exactly the same format and the merging of queries failed.
- ddpl
Please provide sample data which are you using.