Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rohi__
Contributor III
Contributor III

Enter Variabel at Specific Row in Certain Field

Hello everyone,

 

how can i enter a variabel by accessing a certain row number and its field?

 

for example:

alphabeth | name

a | albert

b | boris

d | duncan

 

so there is 'c' missing and i now want to enter at the third position by accessing the row number the line c. 

after:

alphabeth | name

a | albert

b | boris

c | 

d | duncan

 

Thank you very much!

Regards,

rohi__

Labels (6)
5 Replies
sunny_talwar

Is your actually data made up of alphabets? If it isn't then how will we know what is missing?

rohi__
Contributor III
Contributor III
Author

hi sunny!

thanks for your fast reply!

there is nothing missing in my data... 

it s a calendar with specific workdays. the function networkdays() won't work.

i got a column of ordered days and now i want to access each row to enter in the 'workday' column 'yes' or 'no'.

this is a separate table with no dates... so my idea was to add each field separate because they are syncronized by order.

hope you got an answer to this. 

thanks again!

sunny_talwar

I did not, in fact I am more confused now.... we started with alpha-numeric data... but moved over to dates (NetWorkDays)... I think your sample is totally unrelated to your request... can you may be provide a better sample to explain your requirement?

rohi__
Contributor III
Contributor III
Author

sorry for that... 

i fixed my problem with indexing each row with a number and did the same thing in my other table and joined them with the index as key. looks good for now.

thanks for your reply!

sunny_talwar

Okay good to know.