Crosstable Load

[tmumaw]

I'm trying to build a crosstable and keep getting error on my Load of crosstable.  Anyone see anything strange?

Thanks

Thom

Temp2:
Load
Ship_accountid as ShipTo,
ContractStart_Year as Start_YR,
Count(distinct(opportunityid)) as NoOpptunities
Resident Opportunity
Group by Ship_accountid, ContractStart_Year
;
CrossTable (Start_YR,Value,1)
Load
ShipTo
Resident Temp2
;

[jwjackso]

You need to include the fields

CrossTable (Start_YR,Value,1)
Load
ShipTo,

Start_YR,

NoOpptunities
Resident Temp2;
;

Or you could try

Temp2:

CrossTable (Start_YR,Value,1)
Load
Ship_accountid as ShipTo,
ContractStart_Year as Start_YR,
Count(distinct(opportunityid)) as NoOpptunities
Resident Opportunity
Group by Ship_accountid, ContractStart_Year
;

[tmumaw]

This is what I'm seeing:

ShipTo         Start_YR           Value

12345            Start_YR           2019

12345            NoOpportunities   1

I'm seeing 2 lines and I would like to see 1 line with values

[jwjackso · Accepted solution]

A Crosstable converts a row with multiple columns into multiple rows.  You might be looking for the Generic Load 

[tmumaw]

Looking for examples of generic loads.  Does anyone have one to share?  Thanks