Re Cross Tab Configuration

prakashatutd

Hello:

What configuration would provide "one row" in the output?

Thanks!

How to get one row output - Cross Tab example.yxmd

Workflow

Output

Tips and Tricks

Accepted answers

apathetichell

I do not understand your question. Cross Tab is working as expected. Your issue is that you have two values for City - so if City is a key field - you will get two lines - one each for:

San Francisco
San Fransisco

You issue is that San Francisco is mispelled for one of your entries.

All comments

apathetichell

try concatenate.

prakashatutd

Hello:

"Concatenate" is already checked in the configuration. Its not working.

Any other ideas?

apathetichell

I do not understand your question. Cross Tab is working as expected. Your issue is that you have two values for City - so if City is a key field - you will get two lines - one each for:

San Francisco
San Fransisco

You issue is that San Francisco is mispelled for one of your entries.

prakashatutd

Very good catch!! So, "spelling" was the culprit.

Many thanks for resolving it.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703