I have two source files which are updated daily ...
I have created Connections to them, then used Combine Queries/Append to create a combined table with a Custom Column ...
I want to populate the Custom Column with a value depending on which file the record came from ie "Source1" if record comes from the first file, "Source2" if the record comes from the second file ...
Can anyone help me please?
Thanks ...
I have created Connections to them, then used Combine Queries/Append to create a combined table with a Custom Column ...
I want to populate the Custom Column with a value depending on which file the record came from ie "Source1" if record comes from the first file, "Source2" if the record comes from the second file ...
Can anyone help me please?
Thanks ...