Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Position Date Problem

Hello,

I have many tables, one of them has the reception date Test_Consumo_1 (Main Table) , Some codes must be changing with other dates.

I have created an excel file with code and new dates. What I want is change the date excel data into Test_Consumo_1, If not read just the field.

I attached a sample view

Thanks!

Labels (1)
5 Replies
joshabbott
Creator III
Creator III

What is the user id?

pgalvezt
Specialist
Specialist
Author

I have deleted the credentials,

pgalvezt
Specialist
Specialist
Author

Hi,

Could you open the file?

joshabbott
Creator III
Creator III

Yes, I can.  But after looking at it, I'm not understanding exactly what you are trying to do though

pgalvezt
Specialist
Specialist
Author

I have to change the date of some codes for example:

CodigoFecha_PruebaFecha_Realfecha_precepfecha_precep1
L010-OT-00T22337CP10-08-201321-03-201221-03-201210-08-2013

10-08-2013 have to be into fecha_precep (The real value is 21-03-2013) But If(Codigo is L010-OT-00T22337CP so fecha_precep is Fecha_Prueba if not fecha_precep.

If you want delete the resident tables.