Table Transformer

Merge tables preset

Merged table:

Source tables:

Employee	Age	Experience, years	Position
Andy Miller	25	3	Middle front-end developer
Ashley Stone	23	1.2	Junior front-end developer
Jennifer Johnson	24	3.5	Middle front-end developer

Employee	Experience, years	Position	Age
Oliver Black	4	Middle front-end developer	27
Peter Jacobs	1.5	Junior front-end developer	24
Thomas Powell	6	Senior front-end developer	30

Lookup tables preset

Merged table:

Source tables:

Name	Age	Experience, years	Position
Andy Miller	25	3	Middle front-end developer
Ashley Stone	23	1.2	Junior front-end developer
Jennifer Johnson	24	3.5	Middle front-end developer
Oliver Black	27	4	Middle front-end developer
Peter Jacobs	24	1.5	Junior front-end developer
Thomas Powell	30	6	Senior front-end developer

Name	JavaScript	Java	Python	Certification
Andy Miller				UNKNOWN
Ashley Stone				UNKNOWN
Jennifer Johnson				UNKNOWN
Oliver Black				UNKNOWN
Peter Jacobs				UNKNOWN
Thomas Powell				UNKNOWN

Custom transformation using SQL (if-then construct)

SELECT *, CASE WHEN 'Subtotal' < 1000 THEN "LOW" WHEN 'Subtotal' >= 1000 AND 'Subtotal' < 2000 THEN "MEDIUM" ELSE "HIGH" END AS 'Priority' FROM T1

Merged table:

Source tables:

Order date	Store	Items	Subtotal
6/30/2018	Store #3	Date stamp	$1040.00
6/30/2018	Store #1	Printing of envelope A-4 size brown	$2,604.00
6/29/2018	Store #1	Date stamp	$784.00
6/28/2018	Store #1	Rubber band (medium and small size)	$280.00
6/28/2018	Store #2	Plastic folder with visiting card holding sheet	$2,619.00
6/27/2018	Store #1	ID card holder	$420.00
6/27/2018	Store #3	File folder A to Z and 1 to 31	$624.00
6/27/2018	Store #1	File separator A-4 size	$705.00
6/27/2018	Store #1	Rubber band (big size)	$1,656.00
6/27/2018	Store #1	Acknowledgement book	$3,000.00
6/27/2018	Store #3	ID card holder	$3,128.00
6/26/2018	Store #1	Stapler 10-D	$686.00
6/26/2018	Store #3	Office file with clip	$688.00
6/26/2018	Store #3	Plastic folder with hole- A4 size	$732.00
6/26/2018	Store #3	Meeting writing pad	$735.00
6/26/2018	Store #2	Brown paper sheet	$1,024.00
6/26/2018	Store #3	Letter opener	$3,792.00
6/25/2018	Store #2	Notice board size 3x2fit & 5x3fit	$320.00
6/25/2018	Store #2	Writing pad A4 size line	$378.00
6/24/2018	Store #3	Scissors (big)	$78.00
6/24/2018	Store #3	Punching machine 520	$484.00
6/24/2018	Store #2	Visiting card holder	$1,168.00
6/24/2018	Store #2	File separator A-4 size	$2,254.00
6/23/2018	Store #1	File folder A to Z and 1 to 31	$105.00
6/23/2018	Store #3	Desk calculator	$308.00
6/23/2018	Store #2	Thin A4 size paper folder	$310.00
6/23/2018	Store #2	Office tray ( in & out )	$567.00
6/23/2018	Store #2	Eraser	$777.00
6/23/2018	Store #3	Writing pad - A5 size line	$1,444.00
6/23/2018	Store #2	Stapler 10-D	$1,472.00
6/22/2018	Store #2	Calculator paper roll	$484.00
6/22/2018	Store #1	Office file with clip	$696.00
6/22/2018	Store #2	Punching machine 520	$2,125.00
6/22/2018	Store #2	Acknowledgement book	$3,520.00
6/21/2018	Store #1	Writing pad - A5 size line	$703.00
6/21/2018	Store #2	Non dust chalk	$775.00
6/21/2018	Store #1	Thin A4 size paper folder	$968.00
6/21/2018	Store #2	ID card holder	$1,798.00
6/21/2018	Store #3	File separator A-4 size	$3,441.00
6/20/2018	Store #3	Office tray ( in & out )	$510.00
6/20/2018	Store #3	Printing of envelope A-4 size brown	$1,372.00
6/20/2018	Store #1	Plastic folder with visiting card holding sheet	$1,886.00
6/20/2018	Store #1	Gate pass book	$2,214.00
6/20/2018	Store #2	Stamp pad ink	$2,400.00
6/20/2018	Store #1	A4 size plastic file	$3,762.00
6/19/2018	Store #2	Pencil	$432.00
6/19/2018	Store #3	Scale 30 cm & 12 cm	$1,300.00
6/19/2018	Store #2	Binder clips 41mm,32mm,19mm, 51mm	$2,450.00
6/19/2018	Store #1	Notice board size 3x2fit & 5x3fit	$2,475.00
6/19/2018	Store #2	A4 size plastic file	$3,526.00
6/18/2018	Store #3	Key ring	$198.00
6/18/2018	Store #1	Visiting card holder	$448.00
6/18/2018	Store #3	Writing pad A4 size line	$481.00
6/18/2018	Store #3	Acknowledgement book	$646.00
6/18/2018	Store #2	Writing pad - A5 size line	$873.00
6/18/2018	Store #2	Bubble sheet	$884.00
6/18/2018	Store #3	Binder clips 41mm,32mm,19mm, 51mm	$1,128.00
6/18/2018	Store #2	Date stamp	$3,078.00
6/18/2018	Store #2	Gel pen	$3,608.00
6/17/2018	Store #2	File folder A to Z and 1 to 31	$598.00
6/17/2018	Store #2	Meeting writing pad	$984.00
6/17/2018	Store #1	Calculator paper roll	$1,392.00
6/17/2018	Store #2	Paper cutter stand	$3,139.00
6/17/2018	Store #1	Gel pen	$3,268.00
6/16/2018	Store #2	Letter opener	$1,107.00
6/16/2018	Store #3	A4 size plastic file	$1,470.00
6/15/2018	Store #1	Highlighter (yellow,green,orange)	$912.00
6/15/2018	Store #3	Magnetic white board duster	$1,035.00
6/15/2018	Store #1	Binder clips 41mm,32mm,19mm, 51mm	$1,053.00
6/15/2018	Store #1	Scissors (big)	$1,316.00
6/15/2018	Store #3	Bubble sheet	$1,760.00
6/15/2018	Store #2	Rubber band (big size)	$2,520.00
6/15/2018	Store #2	Desk calculator	$2,964.00
6/14/2018	Store #2	Rubber band (medium and small size)	$495.00
6/14/2018	Store #3	Paper cutter stand	$806.00
6/14/2018	Store #1	Letter opener	$3,045.00
6/13/2018	Store #3	Stapler 10-D	$1,440.00
6/13/2018	Store #3	Notice board size 3x2fit & 5x3fit	$1,533.00
6/13/2018	Store #2	Magnetic white board duster	$1,581.00
6/12/2018	Store #3	Visiting card holder	$874.00
6/12/2018	Store #1	Meeting writing pad	$1,161.00
6/12/2018	Store #1	Punching machine 520	$3,150.00
6/11/2018	Store #2	Printing of envelope A-4 size brown	$182.00
6/11/2018	Store #1	Desk calculator	$364.00
6/11/2018	Store #3	Library box	$1,440.00
6/11/2018	Store #3	Stamp pad ink	$1,470.00
6/11/2018	Store #3	Highlighter (yellow,green,orange)	$1,920.00
6/11/2018	Store #2	Scale 30 cm & 12 cm	$2,052.00
6/11/2018	Store #3	Gate pass book	$3,492.00
6/11/2018	Store #1	Office tray ( in & out )	$5,000.00
6/10/2018	Store #3	Gel pen	$140.00
6/10/2018	Store #2	Library box	$770.00
6/10/2018	Store #3	Calculator paper roll	$1,036.00
6/10/2018	Store #1	Non dust chalk	$1,892.00
6/10/2018	Store #3	Brown paper sheet	$2,976.00
6/9/2018	Store #3	Cello tape 1"	$160.00
6/9/2018	Store #1	Library box	$450.00
6/9/2018	Store #3	Plastic folder with visiting card holding sheet	$774.00
6/9/2018	Store #2	Key ring	$1,080.00
6/9/2018	Store #1	Stamp pad ink	$2,300.00
6/9/2018	Store #1	Bubble sheet	$3,589.00
6/8/2018	Store #3	Thin A4 size paper folder	$352.00
6/8/2018	Store #3	Eraser	$760.00
6/8/2018	Store #1	Pencil	$833.00
6/8/2018	Store #1	Scale 30 cm & 12 cm	$1,681.00
6/8/2018	Store #2	Cello tape 1"	$2,160.00
6/7/2018	Store #3	Non dust chalk	$3,772.00
6/6/2018	Store #1	Eraser	$1,176.00
6/5/2018	Store #1	Key ring	$495.00
6/5/2018	Store #2	Highlighter (yellow,green,orange)	$2,726.00
6/4/2018	Store #1	Brown paper sheet	$280.00
6/4/2018	Store #2	Plastic folder with hole- A4 size	$744.00
6/4/2018	Store #1	Plastic folder with hole- A4 size	$1,320.00
6/3/2018	Store #1	Cello tape 1"	$980.00
6/3/2018	Store #2	Scissors (big)	$2,278.00
6/2/2018	Store #3	Tape dispenser	$264.00
6/2/2018	Store #3	Printing of invitation cards	$561.00
6/2/2018	Store #1	Post it 2 x 3	$600.00
6/2/2018	Store #2	A4 size writing pad spiral	$624.00
6/2/2018	Store #2	Gate pass book	$630.00
6/2/2018	Store #2	Stapler HD-45	$726.00
6/2/2018	Store #3	Rubber band (big size)	$880.00
6/2/2018	Store #1	Correction tape	$1,400.00
6/2/2018	Store #3	Printing of envelope cloth lined brown	$1,428.00
6/2/2018	Store #2	Thick A4 size paper folder	$1,575.00
6/2/2018	Store #1	Printing of invitation cards	$1,675.00
6/2/2018	Store #3	Plastic folder A4 size-	$1,740.00
6/2/2018	Store #3	Sticker Sign here	$4,150.00
6/1/2018	Store #1	Writing pad A4 size line	$156.00
6/1/2018	Store #2	Printing of envelope A-5 size brown	$425.00
6/1/2018	Store #3	Rubber band (medium and small size)	$648.00
6/1/2018	Store #2	Office file with clip	$684.00
6/1/2018	Store #3	Flip chart	$851.00
6/1/2018	Store #1	Stapler pins 10	$968.00
6/1/2018	Store #3	Separators/dividers	$1,200.00
6/1/2018	Store #1	Magnetic white board duster	$1,200.00
6/1/2018	Store #2	White board marker	$1,560.00
6/1/2018	Store #1	Paper cutter stand	$1,825.00

Priority
UNKNOWN
UNKNOWN
UNKNOWN

Space shortcuts

Page tree

Merged table:

Source tables:

Merged table:

Source tables:

Merged table:

Source tables: