Dataset creation

[sk]

Hello Team,

We have a requirement where when an enduser selects a region(EMEA, AMERICA, ASIA PACIFIC), 

if user selects EMEA region then it should show (GA,GC) under market, if user selects America region then it should show (NA,LA)

If user selects GA under market then it should show (BALTICS,BULGARIA) under geo, if user selects GC under market then it should show (AFRICA) under geo

Attribute1 - Region

Attribute1- market

Attribute3- Geo

how can we achieve this through data sets.

can someone help on this

[PremMahadikar]

Hi @sk,

1. Have one to one combination of each record (csv file of UTF-8 encoded max 10,000 records) and upload below combinations

• 

2. Follow the documentation to upload the datasets - Creating Datasets (saviyntcloud.com)

3. Once done, Preview screens

• Dataset preview

• Data analyzer  preview

4. Now access the data in dynamic attributes

		Single Select SQL Query
DA1	Region	SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' ORDER BY ATTRIBUTE1 ASC
DA2	Market	SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3 = '${region}' ORDER BY ATTRIBUTE1 ASC
DA3	Geo	SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE2 = '${market}' ORDER BY ATTRIBUTE1 ASC

Configure parent and child DA to achieve selected combinations!

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[sk]

Hi @PremMahadikar ,

THanks for the response.

I have tried with the above approach but the values are not populating under dropdown for Market and Geo

Could you please let me know if I am missing anything here

[PremMahadikar]

@sk ,

I see the dataset value in region DA, which mean the values are retrieved from dataset table. I believe, the query would be correct in other DA as well.

Please make sure, you have proper parent child mapping. 

1. My region DA config

2. My market DA config

Small change in query, use the below. This is working for me.

DA1	Region	SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' ORDER BY ATTRIBUTE1 ASC
DA2	Market	SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' and ATTRIBUTE3=${region} ORDER BY ATTRIBUTE1 ASC
DA3	Geo	SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' and ATTRIBUTE2=${market} ORDER BY ATTRIBUTE1 ASC

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[sk]

It was working fine, Thank you

[PremMahadikar · Accepted solution]

@sk ,

I missed to mention above, small change is 'remove quotes' in child DA. Its ${region} and not '${region}'

SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3=${region} ORDER BY ATTRIBUTE1 ASC

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[PremMahadikar]

@sk,

Thats great it worked! Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.

For the new requirement,

1. Have another combination in your dataset for country and upload the same.
2. As its only for visibility, config the DA exactly like below

It works!

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[sk]

We have one more requirement 

Geo	country (for visibility only)
Adriatics	Croatia
Adriatics	Montenegro
Adriatics	Serbia
Africa	Slovenia

If the user select Geo as 'Adriatics' then it should show country('Croatia',Montenegro,Serbia)

if the user selects Geo as ' Africa' then it should show country ('Slovenia')

The country should be for the visibility purpose only no need of selection

could you please advise