Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Join In-DB tool not reading all the columns from the output of Write Data In-DB tool

nikhil_pra
5 - Atom

Dear Members,

 

Please suggest on below requirement:

 

Database : - Oracle

Requirement :- Reading data from Table-1 and writing in only 4 columns of Table-2. After writing, Table-2 is getting joined with Table-3.

Challenge :- Table-2 have 10 columns but after performing left join with Table-3, I am only getting 4 columns from Table-2. I wanted to have all the 10 columns from Table-2 in my workflow. I wanted to perform this task in the same workflow.

Below is the snippet for the same:

 

nikhil_pra_1-1640170846738.png

 

I am new to the Alteryx, please help.

 

Thanks in advance.

0 REPLIES 0
Labels
Top Solution Authors