Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Combine Coloumn Data with related Rows

itahir04
8 - Asteroid

Hi Alterx Community:

I need help converting this table in a single row record:

   RegionEast
   Vehicle TypeSedan
   MakeHonda
   StateNJ
     
Dealer IdDealership NameYear in BusinessEffective Year 
1001Auto Hub52015Meet

 

 

Desired Output:

 

Dealer IdDealership NameYear in BusinessEffective YearSales TargetRegionVehicle TypeMakeState
1001Auto Hub52015MeetEastSedanHondaNJ

 

Thanks,

Rana

 

 

6 REPLIES 6
fmvizcaino
17 - Castor
17 - Castor

Hi @itahir04 ,

 

Are the tables presented in your example 2 tables or only one in the same sheet?

 

Best,

Fernando Vizcaino

itahir04
8 - Asteroid

Hi Fernando,

Example sheet has the same sample data as posted.

FIrst table is the sample data.

Second table is the desired outcome.

 

Thanks for your assistance.

Rana

itahir04
8 - Asteroid

Hi Fernando,

I have simplified my data set. Hopefully that will help.

Thanks,

Rana

afv2688
16 - Nebula
16 - Nebula

Hello @itahir04,

 

Would this help?

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

itahir04
8 - Asteroid

Hi 

 

itahir04
8 - Asteroid

 Hi 

 

   RegionEastWestSouth
   Vehicle TypeSedanSedanSUV
   MakeHondaToyotaSuburu
   StateNJPAUT
       
Dealer IdDealership NameYear in BusinessEffective Year   
1001Auto Hub52015Not SureNot MeetMeet
1002Auto Heaven102010Not SureNot MeetMeet
1003Auto Bash202000Not SureNot MeetMeet
1004Sanson Toyota301990Not SureNot MeetMeet
Labels