Multiple tables summary in one report

[vallsas]

Dear All,

I have 20 tables and i would like to create a summary report on

as 20 tables i can't join as they are diff tables no common columns.

so 4 tables they have common columns and like that i can create 

four summary tables (like they contain, count of bags, shoes in one table,

other table count of laptops,count of mobiles, other table count of books and number of subjects)

so here the challenge is I want to create a one report alltogether in va 

so the user should be able to all the stats in one report .as they dont have common id to join.

please let me know if you brilliant ideas. 

[Renato_sas]

Hi @vallsas,

If the tables don't have a key to be joined, that's an indication that they shouldn't be joined. Would it make sense to append those tables outside of VA instead? If the tables have no common columns like you said, maybe a bit of data prep to standardize them before the append?

Best,

Renato

[vallsas]

Hi Renato,

thank you.

Yes, i had the same feeling but i thought to check as va can get access multiple tables in one report without join (correct me).

thank you again for the clarification and reply.

[Renato_sas]

Just to clarify, a VA report can access multiple tables, but each VA object (bar chart, crosstab, etc.) can be fed by only one table.

Best,

Renato