Forum Discussion
relations
Hi,
I've two tabels:
Employee Consult and Scanvragen MC. In the tabel Employee Consult are colomns with questionscores. The name of the colomn is the code of te question. The questions with the codes are in the second table, Scanvragen MC. I want tot report from te first table the quistionscores with the questionteks form te second table. I don't know how to do that.
6 Replies
jaspijk ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.thansks for your quick reply!
In tehe first tabel You see the colomns ECCO001, ECCO002, ECCO003, ....... The colomn-names are corespondending with a field in he second table 'vraagcode'. I want tot use 'vraagtekst' from the second table as the colomnames of the first to report the results. So instead of reporting ECCO001 with the everagescore of 89, I want to report the corrrespondeding text woth tehe score.
Now I get:
And I want:
'Dat de organisatie een duidelijke visie heeft' (text in the second table)
89
Hi,
Was my econd message clear enough for You?
The idea is you first need to transport or pivot the first table in to something like:
Code Employee 1 Employee 2 ECMW001 60 100 ECMW002 60 100 ECMW003 60 80 ECMW004 60 80 etc.... Then once you related the 2 tables with Code columns, you can just drage code, question, employee scores to a table visual in the report.
However, you could provide the sample pbix file if you need a definite solution.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Anonymous
Thanks for Your reply. Where can I find the sample pbix?
Jacques
Still not found a solution. Don't know how to pivot the first table in a correct way.
