Forum Discussion
Date Columns in Different Data Sets
Hi, I have two sata sources which I need to have the dates combined as one. Essentially all rows from the SERVCARD data will either have an invoiced date from the SERVCARD data or an invoic...
v-yinliw-msft
Community Support
Community SupportHi dhodgson ,
You can try this method:
Merge the INV Date column to SERVCARD table:
SERVCARD table:
INVOICE table:
Transform data:
In SERVCARD table:
Is this what you expect?
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.