Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reduce and Loop by NT Username

Hello everyone,

I have many QVW application having all my regional countries data but when i distribute the document into the Publisher i have to distribute by countries wise for local team people.

Lets assume:

My fact table:

Item,

category,

country,

date,

uintcost,

paidprice

Now what i did I have created one more table for reduce by NTNMAE .

NTNAME:

country,

NTNAME  (format - Domain\user)


I have created the task like below screenshot but it doesn't work and I am getting only warning error. i really don't know why and i have referred many blog and tutorials.

Reduce.png  


Loop Field in Document.png

I have attached the log file also for your reference. could you please advise how to fix this ?

Best,

Robert

12 Replies
ali_hijazi
Partner - Master II
Partner - Master II

when you create an inline table then the values of NTNAME should match the casing of the values in the section access

for testing purposes remove the section access and see how NTNAME is coming in the table of section access it should match the case you use in the inline table

I can walk on water when it freezes
Not applicable
Author

hi Ali

Is this configuration requires active directory, or just normal NT Authentication

Thanks

-wandi

Not applicable
Author

Hello all,

I find the solution for my question with help of my colleague(Wandi ).

We haven't add the local directory path in our QMC server after added its works perfect.

Loca directory.png

Thanks wandi.

Best,

Robert