Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

schem mapping tables source to target

Hi, 

I would like to know if it possible with ALTERYX Designer to perform schema mapping from source to target with table/column mapping that would  show the difference and matches where possible between two files 

 

on Alteryx designer 11.7 

 

EXAMPLE : SOURCE  INPUT FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJSMYIDANUMBER
RTVSJSVERSIONNUM1NUMBER1

 

EXAMPLE : TARGET   INPUT FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJBMYIDNUMBER
RTVSJBVERSIONNUM1NUMBER

 

EXAMPLE : OUPTUT RESULT  FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJS - NO MATCHMYIDNUMBER
RTVSJS - MATCH VERSIONNUM1NUMBER

 

Highlighted
Magnetar
Magnetar

Hi @sbellinialt ,

 

What about a Join tool, joining on all of the fields? Anything that doesn't map will come out of the left or right input. You could use a formula tool to add the "no match"  or "match" either to an existing field or new field, and then union everything back together.

 

Cheers!

Esther

 

Highlighted

Would it be possible to do this with Alteryx Workflow by using tool sql ?

Labels