hola amigos..
¿Hay alguna manera de combinar mis consultas? Aquí está la lista de consultas tomadas del editor de avanzada.
Dejar
Fuente: Table.Combine(-PROD1516, PROD1617, PROD1718, PROD1819, PROD1920, CAB1516, CAB1617, CAB1718, CAB1819, CAB1920, SPS1516, SPS1617, SPS1718, SPS1819, SPS1819, SPS1920),
"Columna condicional agregada" - Table.AddColumn(Source, "DOMESTIC", cada uno si Text.StartsWith([PRODUCT], "DMS") y luego "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "SHR") a continuación, "DOMESTIC"
si Text.StartsWith([PRODUCTO], "FRH") y, a continuación, "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "CHR") a continuación, "DOMESTIC"
si Text.StartsWith([PRODUCTO], "AQUAGOLD") y luego "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "AQUAMINI") a continuación, "DOMESTIC"
si Text.StartsWith([PRODUCT], "ASMSP") entonces "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "HCS") entonces "DOMESTIC"
si Text.Contains([PRODUCT], "ELITE") entonces "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "DMH") a continuación, "DOMESTIC"
de lo contrario si Text.StartsWith([PRODUCTO], "LCS") a continuación, "DOMESTIC"
si Text.StartsWith([PRODUCT], "TSJ") entonces "DOMESTIC"
si Text.StartsWith([PRODUCTO], "TVJ") y, a continuación, "DOMESTIC"
si Text.StartsWith([PRODUCTO], "HTT") y luego "DOMESTIC" else "OTHERS"),
"Columna condicional agregada1" á Table.AddColumn(''Columna condicional agregada'", "DISTZERO", cada una si [TOTALVAL] á 0 entonces "DISTRICT ZERO" else "DT"),
"CABLES CUSTOM COLUMN" - Table.AddColumn(''Columna condicional agregada1", "Custom",
cada uno si [PRODUCTO] - "CABLE DE PISO SUMERSIBLE 3 CORE 1*3*1.5 SQ. MM" entonces "1.5 BG"
de lo contrario si [PRODUCTO] - "CABLE DE PISO SUMERSIBLE 3 CORE 1*3*2.5 SQ. MM" entonces "2.5 BG"
de lo contrario si [PRODUCTO] - "CABLE DE PISO SUMERSIBLE 3 CORE 1*3*4.0 SQ. MM" entonces "4.0 BG"
de lo contrario si [PRODUCTO] á """AQUATEX"" 1X3X6.0 SQ. MM XLPE FLAT CABLE (LW-XLPE CL)" y luego "6.0 XLPECL" en else "EMP"),
"Columnas renombradas" - Table.RenameColumns("CABLES CUSTOM COLUMN","Custom", "CABLE SIZE"-),
"Valor reemplazado" ? Table.ReplaceValue(?"Columnas renombradas","[CANCELLED] ","",Replacer.ReplaceText,-"DEALER"-),
"Valor reemplazado1" á Table.ReplaceValue(?"Valor reemplazado","[CANCELLED] ","",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"Valor reemplazado2" á Table.ReplaceValue(?"Valor reemplazado1","[CANCELED]","",Replacer.ReplaceText,"DLR NAME_DEST"-),
"Valor reemplazado3" á Table.ReplaceValue(?"Valor reemplazado2","[CANCELLED ] ","",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"Valor reemplazado4" á Table.ReplaceValue(?"Valor reemplazado3","[CENCELLED] ","",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"Valor reemplazado5" - Table.ReplaceValue(?"Valor reemplazado4","[cancelado]","",Replacer.ReplaceText,"DLR NAME_DEST"-),
"Valor reemplazado6" - Table.ReplaceValue("Valor reemplazado5","AGENCIAS de MERCADO DE TEX.","AGENCIAS DE MERCADO DE TEX",Replacer.ReplaceText,"DLR NAME_DEST"-),
"Valor reemplazado7" - Table.ReplaceValue(?"Valor reemplazado6","PREMIER MARKETING","PREMIER ENGINEERS",Replacer.ReplaceText,"DLR NAME_DEST"-),
"Valor reemplazado8" - Table.ReplaceValue(?"Valor reemplazado7","[CANCELLED]","",Replacer.ReplaceText,"DLR NAME_DEST"-),
"BANGALORE TO BENGALURU" - Table.ReplaceValue("Replaced Value8","BANGALORE","BENGALURU",Replacer.ReplaceText,"DLR NAME_DEST"-),
"HOSKOTE TO HOSOKOTE" - Tabla.ReplaceValue("BANGALORE TO BENGALURU","HOSKOTE","HOSOKOTE",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PREMIER MKT TO ENGINEERS" - Table.ReplaceValue("HOSKOTE TO HOSOKOTE","PREMIER MARKETING","PREMIER ENGINEERS",Replacer.ReplaceText,"DLR NAME_DEST"-),
"THAMMAM PATTY TO THAMMAMPATTY" - Table.ReplaceValue("PREMIER MKT TO ENGINEERS","THAMMAM PATTY","THAMMAMPATTY",Replacer.ReplaceText,"DLR NAME_DEST"-),
"ADP TO A.D.P.CO" - Table.ReplaceValue("THAMMAM PATTY TO THAMMAMPATTY","A.D.P ELECTRICALS CHINGLEPET","A.D.P.CO., CHENGALPATTU",Replacer.ReplaceText,"DLR NAME_DEST"-),
"MANI ELECTRICALS" - Table.ReplaceValue(ADP TO A.D.P.CO","MANI ELECTRICALS [VILU]","MANI ELECTRICALS",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PADMANABHAN ELECTRICALS" ? Table.ReplaceValue("MANI ELECTRICALS","PADMANABHA ELECTRICALS","PADMANABAN ELECTRICALS",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SRI SELVAVAGANAPTHY" - Tabla.ReplaceValue("PADMANABHAN ELECTRICALS","SRI SELVAGANAPATHY ENGINEERING PANJATTI","SRI SELVA GANAPATHY ENGINEERING PONNERI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SUSEELA ELECTRICALS" - Table.ReplaceValue('SRI SELVAVAGANAPTHY","SUSEELA ELECTRICALS PANRUTTI","SUSILA ELECTRICALS PANRUTI",Replacer.ReplaceText,''DLR NAME_DEST"'),''
"ANANDA PIPES" á Table.ReplaceValue("SUSEELA ELECTRICALS","ANANDA PIPES","ANANTHA PIPES",Replacer.ReplaceText,"DLR NAME_DEST"-),
"BOMBAY ELECTRICALS" ? Table.ReplaceValue("ANANDA PIPES","BOMBAY ELECTRICALS","BOMBAY MOTOR & PIPES",Replacer.ReplaceText,"DLR NAME_DEST"-),
"FATIMA ELECTRICALS" - Table.ReplaceValue("BOMBAY ELECTRICALS","FATIMA ELECTRICALS","FATIMA AGENCY",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANDAN ELECTRICALS" - Table.ReplaceValue("FATIMA ELECTRICALS","KANDAN ELECTRICALS","KANDAN ELECTRICAL AGENCIES",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KASIM STORES" ? Table.ReplaceValue("KANDAN ELECTRICALS","KASIM STORES SIVAGANGAI DIST","KASIM STORES KARAIKUDI",Replacer.ReplaceText,"DLRNAME_DEST", NAME_DEST,
"SIDDHIAH KVL TO VILATHI" - Table.ReplaceValue("KASIM STORES","SIDDHIAH ELECTRICALS KOVILPATTI","SIDDHIAH ELECTRICALS VILLATHIKULAM",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SIDDHIAH VIL TO VILLATHI" - Tabla.ReemplazarValor('SIDDHIAH KVL TO VILATHI',"SIDDHIAH ELECTRICALS VILATHIKULAM","SIDDHIAH ELECTRICALS VILLATHIKULAM",Replacer.Replacetext,"DLR NAME_DEST"-),
"YUGAN PUMPS" - Table.ReplaceValue("SIDDHIAH VIL TO VILLATHI","THIRUMANGALAM,"THIRUMANGALAM",Replacer.ReplaceText,"DLR NAME_DEST"-),
"MDU PIPES" á Table.ReplaceValue("YUGAN PUMPS","MaduraI PIPE MADURAI TOWN","MaduraI PIPES MaduraI TOWN",Replacer.ReplaceText,"DLR NAME_DEST"-),
"DEEPIKA ELECTRICALS" ? Table.ReplaceValue("MDU PIPES","DEEPIKA ELECTRICALS [MULANUR] MULANUR","DEEPIKA ELECTRICALS MULANUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"AGENCIAS DE BASAVESWARA" - Tabla.ReplaceValue("DEEPIKA ELECTRICALS","BASAVESWARA AGENCIES [DAVANAGERE] DAVANAGERE","BASAVESHWARA AGENCIES [DAVANAGERE] DAVANAGERE",Replacer.Replacer.ReplaceText,"DLR NAME_DEST"-),
"MSR ENGINEERING" - Table.ReplaceValue("BASAVESWARA AGENCIES","MSR ENGINEERING NAYUDUPET","MSR ENGINEERINGS NAIDUPET",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANCHSHEEL TRADERS" - Table.ReplaceValue("MSR ENGINEERING","PANCHSHEEL TRADERS [HUB] GHATAPRABHA","PANCHASHEEL TRADERS [HUB] GHATAPRABHA",Replacer.Replacer.ReplaceText,"DLR NAME_DEST"-),
SEMITRONICS á Table.ReplaceValue('PANCHSHEEL TRADERS',"SEMITRONICS THODUPUZHA","SEMITRONICS [THO] THODUPUZHA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI AGARWAL MACHINERY" - Table.ReplaceValue(SEMITRONICS,"AGARWAL MACHINERY JANJGIR","AGARWAL MACHINERY STORES JANJGIR-NAILA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI AMAR BROS" - Table.ReplaceValue(?"RAI AGARWAL MACHINERY","AMAR BRO'S RAJNANDGAON","AMAR BROTHERS RAJNANDGAON",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI BHATIA" - Table.ReplaceValue("RAI AMAR BROS","BHATIA ELECTRICAL & GENERAL STORES DONGARGARH","BHATIA ELECTRICALS & GENERAL STORE DONGARGARH",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI GUPTA TRDS" - Table.ReplaceValue(''RAI BHATIA',"GUPTA TRADERS BEKUNTHPUR","GUPTA TRADERS BAIKUNTHPUR",Replacer.ReplaceText,''DLR NAME_DEST''),
"RAI GURUNANAK" ? Tabla.ReplaceValue("RAI GUPTA TRDS","GURU NANAK HARDWARE STORES KANKER","GURUNANAK HARDWARE STORES KANKER",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI SHIVSHANKAR" - Tabla.ReplaceValue("RAI GURUNANAK","SHIVSHANKAR ELECTRICALS KAWARDHA","SHIVSHANKAR ELECTRICALS [RAI] KAWARDHA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"RAI MUKESH ELECT" - Table.ReplaceValue(?"RAI SHIVSHANKAR","MUKESH ELECTRICAL & ELECTRONIC DHARAMJAYGARH","MUKESH ELECTRICAL & ELECTRONIC DHARAMJAIGARH",Replacer.Replacetext,"DLR NAME_DEST"-),
"RAI NANAGRAM MURLI" - Table.ReplaceValue('RAI MUKESH ELECT","NANAGRAM MURLIDHAR BILASAPUR","NANAGRAM MURLIDHAR BILASPUR",Replacer.ReplaceText,''DLR NAME_DEST''),
"RAI CHATTISGARH" - Table.ReplaceValue("NANA RAIGRAM MURLI","CHHATISGARH KRISHISEVA KENDRA AMBIKAPUR","CHHATTISGARH PUMP & MACHINERY AMBIKAPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND A.K.ELECTRICALS" - Table.ReplaceValue(''RAI CHATTISGARH',"A.K.ELECTRICAL VAIDHAN","A.K.ELECTRICAL WAIDHAN",Replacer.ReplaceText,''DLR NAME_DEST''),'''
"IND BHARAT ELEC MHOW" - Table.ReplaceValue("IND A.K.ELECTRICALS","BHARAT ELCLS. & MACHNY. STORES MHOW","BHARAT ELCLS. & MACHNY. STORES [MHOW] MHOW",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"IND GOPALDAS HIRA" - Table.ReplaceValue("IND BHARAT ELEC MHOW","GOPALDAS HIRANAND & SONS REWA","GOPALDAS HIRANAND PRIVATE LIMITED GOLPARK",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND HARIOM KRISHI" - Tabla.ReplaceValue("IND GOPALDAS HIRA","HARI OM KRISHI SEWA KENDRA GAUTAMPURA/SANWER","HARI OM KRISHI SEWA KENDRA GAUTAMPURA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND JAIN ELECTRICALS" - Table.ReplaceValue("IND HARIOM KRISHI","JAIN ELECTRICALS BINAGUNJ","JAIN ELECTRICALS BINAGANJ",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND KANCHAN MACHINERY" - Table.ReplaceValue("IND JAIN ELECTRICALS","KANCHAN MACHINERY SHYAMGARH","KANCHAN MACHINERY SHAMGARH",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND SNT ENTERPRISES" ? Table.ReplaceValue("IND KANCHAN MACHINERY","S.N.T. ENTER PRISES TAL","S N T ENTERPRISES TAL",Replacer.ReplaceText,"DLR NAME_DEST"-),
"IND MAHESWARI PIPE" - Table.ReplaceValue("IND SNT ENTERPRISES","MAHESWARI PIPE FITTINGS CO. BHOPAL","MAHESHWARI PIPE FITTING CO NAME_DEST.
"JAI GEHLOT" - Table.ReplaceValue("IND MAHESWARI PIPE","GEHLOT MACHINERY STORE [DMN] DHORIMANA","GEHLOT MACHINERY STORE [DMN] DHORIMANNA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI GEHLOT DMN1" - Table.ReplaceValue("JAI GEHLOT","GEHLOT MACHINERY STORES [DHO] DHORIMANA","GEHLOT MACHINERY STORE [DMN] DHORIMANNA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI GAURISHANKAR" - Tabla.ReemplazarValor("JAI GEHLOT DMN1","GOURI SHANKAR FILLING STATION MAULLASAR","GOURISHANKAR FILLINGSTORE MULLASAR",Replacer.ReplaceText,''DLR NAME_DEST"','
"JAI GAURISHANKAR1" - Tabla.ReplaceValue("JAI GAURISHANKAR","GOURI SHANKAR FILLING STORE DIDWANA","GOURISHANKAR FILLING STORE MULLASAR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI HIND IRRIGATION" ? Tabla.ReplaceValue("JAI GAURISHANKAR1","HIND IRRIGATION PRIVATE LTD GANGAPUR","HIND IRRIGATION GANGAPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI JAIJAPIPE" - Tabla.ReplaceValue("JAI HIND IRRIGATION","JAI RAM PIPE TRADERS DUNGARGARH","JAI RAM PIPE TRADERS SRI DUNGARGARH",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI MAHESWARIAGY" - Table.ReplaceValue("JAI JAIRAMPIPE","MAHESHWARI AGENCIES [BEWAR] BEAWAR","MAHESHWARI AGENCIES [BEWAR] BEAWER",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI PRAKASHAGY" - Tabla.ReplaceValue("JAI MAHESWARIAGY","SHREE PRAKASH AGENCY PIPLU","SHREE PRAKASH AGENCY [PIPLU] PIPLU",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI SAMARTH" - Tabla.ReemplazarValor("JAI PRAKASHAGY","SHRI SAMARTH ELECTRIC STORE BIJAINAGAR","SHRI SAMARATH ELECTRIC STORE BIJAI NAGAR,",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI SAMARTH1" - Tabla.ReemplazarValor("JAI SAMARTH","SAMARTH ELECTRIC STORE BIJAINAGAR","SHRI SAMARATH ELECTRIC STORE BIJAI NAGAR,",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI SONYTRDS" á Table.ReplaceValue("JAI SAMARTH1","SONY TRADERS [OLD] JODHPUR","SONY TRADERS JODHPUR,",Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI SHIVSAKTHI" - Tabla.ReplaceValue("JAI SONYTRDS","SHIVSHAKTI ELECTRICALS SAYALA","SHIV SHAKTI ELECTRICALS (JAI) SAYALA,",Replacer.Replacer.ReplaceText,"DLR NAME_DEST"-),
"JAI SURANA" á Table.ReplaceValue("JAI SHIVSAKTHI","SURANA ELECTRIC CHITTORGARH ","SURANA MACHINERY STORE CHITTORGARH,",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC ARAMAKRISHNAMA"-Tabla.ReemplazarValor("JAI SURANA","A.RAMAKRISHNAMMA SALES CORPORATION [KHM]. KHAMMAM","A.RAMAKRISHNAMMA SALES CORPORATION KHAMMAM",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC KRISHNA"-Table.ReplaceValue("SEC ARAMAKRISHNAMA","KRISHNA AGENCIES KALWAKURTHY","KRISHNA AGENCIES. KALWAKURTHY",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC MADEENA"-Table.ReplaceValue('SEC KRISHNA","MADEENA ENGINEERING & HARDWARE CHOPPADANDI","MADEENA ENGINEERING & ELECTRICALS CHOPPADANDI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC MAHADEV"-Table.ReplaceValue("SEC MADEENA","MAHADEV ELECTRICAL & ENGG. OBRAS SRINIVAS NAGAR","MAHADEV ELECTRICAL & ENGG. WORKS SRINIVAS NAGAR,SIDDIPET",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC RAGHU"-Table.ReplaceValue("SEC MAHADEV","RAGHU ELECTL, ELECTRONICS & GEN. STORES WYRA","RAGHU ELECTL,ELECTRONICS&GEN. STORES WYRA",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"SEC SAI VENKAT"-Table.ReplaceValue("SEC RAGHU","SAI VENKAT ELECTRICAL WORKS KOTHAKOTA","SAI VENKAT ELECTRICAL WORKS. KOTHAKOTA",Replacer.ReplaceText,-"DLR NAME_DEST"-),
"SEC SATHYANARAYAN"-Table.ReplaceValue("SEC SAI VENKAT","SATYANARAYANA And COMPANY [JAM] JAMMIKUNTA","SATYANARAYANA Y EMPRESA JAMMIKUNTA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC SHIVA SAI"-Table.ReplaceValue("SEC SATHYANARAYAN","SHIVA SAI ELECTLS & ENGINEERING CO; CHANDUR","SHIVA SAI ELECTRICALS & ENG.,CO CHANDUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SEC SRI LAXMI"-Table.ReplaceValue("SEC SHIVA SAI","SRI LAXMI ELECTRICALS & ENG.CO. MALL","SRI LAXMI ELECTRICALS & ENGG.CO MALL",Replacer.ReplaceText,"DLR NAME_DEST"-),
"AGUA SEC PARA LA VIDA"-Tabla.ReemplazarValor("SEC SRI LAXMI","AGUA PARA SISTEMAS DE VIDA Y SERVICIOS HYDERABAD","AGUA PARA SISTEMAS DE VIDA Y SERVICIOS SECUNDERABAD",Reemplazar.ReemplazarTexto,"DLR NAME_DEST"-),
"SEC SAIKRIPA"-Table.ReplaceValue(''SEC WATER FOR LIFE',"SRI SAI KRUPA ELECTRICALS [MEHDI] HYDERABAD","SRI SAI KRUPA ELECTRICALS [MEHDI] MDPT,HYDERABAD",Replacer.Replacer.ReplaceText,''DLR NAME_DEST''),
"SEC TIRUMALAAGY"-Tabla.ReplaceValue("SEC SAIKRIPA","TIRUMALA AGENCIAS [VKB] VIKARABAD","TIRUMALA AGENCIAS. VIKARABAD",Replacer.ReplaceText,"DLR NAME_DEST"-),
"TCRKEYAR",Table.ReplaceValue("SEC TIRUMALAAGY","KEYAR AGENCIES TRICHUR","KEYAR TRADING CORPORATION TRICHUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"TCRPUMPHOUSE"-Table.ReplaceValue("TCRKEYAR","PUMB HOUSE KANNUR","PUMP HOUSE KANNUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"AHDPARMER",Tabla.ReplaceValue("TCRPUMPHOUSE","PARMAR ENGINEERING CO SURENDRANAGAR","PARMAR ENGINEERING COMPANY SURENDRANAGAR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"AHDPATEL"-Tabla.ReemplazarValor("AHDPARMER","PATEL ENGINEERING CO NAVAGAM(BHAVNAGAR)","PATEL ENGINEERING CO BHAVNAGAR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"AHDREKHA",Table.ReplaceValue("AHDPATEL","REKHA INDUSTRIAL CORPORATION NAVAGAM","REKHA INDUSTRIAL CORPORATION RAJKOT",Replacer.ReplaceText,"DLR NAME_DEST"-),
"BLRGURU TUMKUR"-Tabla.ReplaceValue("AHDREKHA","GURU ASSOCIATES [TUM] TUMKUR","GURU AGENCIES TUMKUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"BLRGURU ASSOCIATES"-Tabla.ReplaceValue("BLRGURU TUMKUR","GURU ASSOCIATES [BLR] BENGALURU","GURU ASSOCIATESBENGALURU",Replacer.ReplaceText,"DLR NAME_DEST"-),
"GBDGARG",Tabla.ReplaceValue("BLRGURU ASSOCIATES","GARG AGRO FIELD PACHO KHARA","GARG AGRO FIELD PACHOKARA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"GBDPRATAP",Tabla.ReplaceValue("GBDGARG","PRATAP MACHINERY STORE SHERGAUR","PRATAP MACHINERY STORE SHERGARH",Replacer.ReplaceText,"DLR NAME_DEST"-),
"HUBGURUASSOCIATES"-Table.ReplaceValue(''GBDPRATAP',"GURU ASSOCIATES [BLR] [HUB] BENGALURU","GURU ASSOCIATES [BLR] BENGALURU",Replacer.ReplaceText,''DLR NAME_DEST"'),
"HUBGURUTUMKUR"-Tabla.ReplaceValue("HUBGURUASSOCIATES","GURU ASSOCIATES [TUM] [HUB] TUMKUR","GURU ASSOCIATES [TUM] TUMKUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"HUBGURUTUMKUR1"-Tabla.ReplaceValue("HUBGURUTUMKUR","GURU ASSOCIATES [TUM]] TUMKUR","GURU ASSOCIATES [TUM] TUMKUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"HUBKAILASELEC"-Tabla.ReplaceValue("HUBGURUTUMKUR1","KAILAS ELECTRICALS SHAHAPUR","KAILAS ENGINEERING SHAHAPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANAHINSA"-Tabla.ReplaceValue("HUBKAILASELEC","AHINSA PUMP Y SALES AGRA","AHINSA PUMP And SALES [GBD AGRA]",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANHARYANA"-Table.ReplaceValue("KANAHINSA","HARYANA PUMP & TUBEWELL STORES MAINPURI","HARYANA PUMP & TUBEWELL STORES [GBD] MAINPURI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANJADON"-Table.ReplaceValue("KANHARYANA","JADON MACHINERY STORE FATEHABAD","JADON MACHINERY STORE [GBD] FATEHABAD",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANRAVIMACHNY"-Table.ReplaceValue("KANJADON","RAVI MACHINERY STORES RAE BARELI","RAVI MACHINERY And SANITARY RAEBARELI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KANRAVITRADERS"-Table.ReplaceValue("KANRAVIMACHNY","RAVI TRADER'S NANDGANJ","RAVI TRADERS NANDGANJ",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KOLBURDWAN"-Table.ReplaceValue("KANRAVITRADERS","BURDWAN CENTRAL Co.Op. AGRICULURAL. MEMARI","BURDWAN CENTRAL CO. FUNCIONAMIENTO AGRICULTURAL OPERATIVO",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KOLKISHAN"-Tabla.ReemplazarValor("KOLBURDWAN","KISHAN MACHINERY ASANSOL","KISAN MACHINERY ASANSOL",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KOLLACHMITRDS"-Tabla.ReemplazarValor("KOLKISHAN","LACHHMI ENGINEERING MALDAH","LACHHMI TRADERS MALDA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KOLSREEPALI"-Table.ReplaceValue("KOLLACHMITRDS","SREEPALI HARDWARE","SREEPALI HARDWARE MEDINIPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"KOLSRIMA"-Tabla.ReplaceValue("KOLSREEPALI","SRIMA ENTERPRISE. RAIDIGHT","SRIMA ENTERPRISE RAIDIGHI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"NAGGBSONS",Tabla.ReplaceValue("KOLSRIMA","G.B.SONS CHANDRAPUR","G B SONS CHANDRAPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"NAGRAMAMCHY"-Table.ReplaceValue("NAGGBSONS","RAMA MACHINERY NAGPUR","RAMA MACHINERIES NAGPUR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANBHANIBORING"-Tabla.ReplaceValue("NAGRAMAMCHY","BHAINI BORING CO TAPA","BHANI BORING CO., TAPA MANDI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANDESONDHI"-Table.ReplaceValue("PANBHANIBORING","DESONDHI RAM TRILOK CHAND MOGA","DESONDHI RAM TIRLOK CHAND MOGA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANGULABRAI"-Tabla.ReplaceValue("PANDESONDHI","GULABRAI OMPRAKASH BUDHIA HISSAR","GULAB RAI OM PRAKASH HISSAR",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANKCTRDG"-Tabla.ReemplazarValor("PANGULABRAI","K.C.TRADING CORPORATION TARN TARAN","K C TRADING CORPORATION TARN TARAN",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PANNATIONALAGY",Table.ReplaceValue("PANKCTRDG","NATIONAL AGRICULTURE AGENCY BATHINDA","NATIONAL AGENCIES BATHINDA",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PATCHAMPARAN",Table.ReplaceValue("PANNATIONALAGY","CHAMPARAN AGRO AGENCY MOTIHARI","CHAMPARAN UTILITY STORE MOTIHARI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PATCHAUDHRY"-Table.ReplaceValue("PATCHAMPARAN","CHAUDHARY ELECTRICALS LAKHISARAI","CHAUDHARY & SONS LAKHISARAI",Replacer.ReplaceText,"DLR NAME_DEST"-),
"PATGDKHANDELWAL"-Table.ReplaceValue("PATCHAUDHRY","G.D. KHANDELWAL SASARAM","G.D.KHANDELWAL SASARAM",Replacer.ReplaceText,"DLR NAME_DEST"-),
"SECWATERPROJ" - Table.ReplaceValue(PATGDKHANDELWAL,"WATER FOR LIFE SYSTEMS AND SERVICES (PROJECT) HYDERABAD","WATER FOR LIFE SYSTEMS AND SERVICES SECUNDERABAD",Replacer.ReplaceText,"Reemplazar.ReemplazarTexto,"DLR NAME_DEST"})
in
SECWATERPROJ
