Joining two crosstables in data load editor

[rds694]

Hi all, I'm trying to do a bar graph with two dimensions at the group and bar level. In order to make it easy to filter on, I used crosstables for both dimensions (Group 1 and Group 2). At first I joined them together in the data manager, but I'm realizing it's actually better to do it now in the data load editor. However, I'm getting the following error when I try to do it:

Is it possible to do a join with two crosstables? If so, how do I do it.

[Andrea_Spinetti]

Hi @rds694, thank you for posting! At first glance, this error may be caused due to synthetic keys generated by the tables joined and not dropped after the join. Also, you may find it useful to know the Crosstable function, used to turn a cross table into a straight table.

I would also suggest having a look at the following help page for best practices: Working with crosstables in the data load script