ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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