Home

Merge Queries Identifying source

%3CLINGO-SUB%20id%3D%22lingo-sub-583153%22%20slang%3D%22en-US%22%3EMerge%20Queries%20Identifying%20source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583153%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20merge%20two%20datasets%20with%20a%20left%20outer%20join%20(All%20from%20first%20file%20and%20excluding%20the%20repeated%20values%20on%20the%20second%20file)%2C%20but%20in%20the%20final%20merged%20table%2C%20I%20need%20to%20add%20a%20column%20that%20identifies%20what%20is%20the%20source%20(File%20name%20can%20work).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20add%20such%20column%2Fidentifier%3F%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583153%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Jul_Sanz
Occasional Visitor

Hello!,

 

I need to merge two datasets with a left outer join (All from first file and excluding the repeated values on the second file), but in the final merged table, I need to add a column that identifies what is the source (File name can work).

 

Is there a way to add such column/identifier? thanks!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies