I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has 1 million records. I would like to replicate only 100 records from each table.

Hi All,

Requirement: I know how to do calculations  but I need help how to input/handle data like monthly associated with (P Release date) and calculate monthly data in the table. (do i need any counter or loop or group by with resident load in script) ? 

I have a huge data (P Release Date) from 2019 to current but here I am using inline table (sample data) to understand the requirements.

Inline Table (data):

main:
load * inline [
P Release Date, Deleted On, PO Release Date
12/21/2022, -, 1/18/2023
12/23/2022, 2/27/2023, -
12/27/2022, -, -
1/4/2023, 1/24/2023, -
1/4/2023, -, 1/17/2023
1/4/2023, -, 2/28/2023
1/4/2023, -, 11/30/2023
1/6/2023, -, 2/9/2023
1/6/2023, -, 2/16/2024
1/11/2023, 5/10/2023, -
1/17/2023, 3/17/2023, -
1/17/2023, -, 4/11/2023
2/2/2023, -, 2/7/2023
2/2/2023, -, 6/21/2023
2/6/2023, 6/6/2023, -
2/15/2023, 9/11/2023, -
2/15/2023, -, 3/14/2024
3/2/2023, -, 5/3/2023
3/2/2023, -, 8/16/2023
3/2/2023, -, 9/22/2023
3/6/2023, -, 1/2/2024
3/30/2023, 4/11/2023, -
3/30/2023, 6/7/2023, -
3/30/2023, 8/7/2023, -
3/30/2023, -, 4/20/2023
3/30/2023, -, 8/29/2023
];

Output Result (in the table):

Calculated Columns 1, 2. 3, 4, and 5.

Calculation 1 :

P Release Date is before start of month

Deleted On is blank

PO Release Date is blank

Calculation 2 :

P Release Date is before start of month

Deleted On is blank

PO Release date is after start of month

Calculation 3 :

P Release Date is before start of month

Deleted On is after start of month

PO Release Date is blank

Calculation 4 :

P Release Date is before start of month

Deleted On is after start of month

PO Release Date is after start of month

Calculation 5 :

Add 1, 2, 3, and 4.

Thanks in advance.

Sara.

I want to use buttons to navigate to a field but its not working , I dont want to use a filter pane I want separate buttons 

ive tried using =(if(WildMatch([OWNING_PATCH],'NORTH'),0)) but it wont work 

can anyone help please 

Dear Community,

Is there a way to display table rows in two colors, similar to the attached Excel version? (The color is unimportant)

I would be very grateful for any help.

Best regards

Here's the scenario:

I am creating multiple bookmarks for the same sheet; the only difference for each bookmark is that the layout is changed for a pivot table and the bookmarks are meant to be an easy way for users to get the drill-down order they desire for the pivot table. 

Because the user may have already selected other filters, I do not want those filters to be cleared when they select a bookmark to change the layout of the pivot table. Is it possible to do this?

Hi All, 

So I have two Tables 

MKDP & MDTB

I need to take all of the rows of field DTNUM in MKDP and get all of the Matching rows in MDTB, and then use the remaining columns from MDTB to build the data set. 

The below is the code thus far 

However when used the fields such as PLUMI from MDTB are blank

Any Help is greatly received

LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];

[MKDP]:
LOAD
    HVR_ROWID,
    SHSTOVAR_SYNC_TIMESTAMP,
    MANDT,
    DTART,
    MATNR,
    PLWRK,
    PLSCN,
    DTNUM,
    DSDAT,
    BDBKZ,
    SLKZ1,
    SLKZ2,
    SLKZ3,
    SLKZ4,
    SLKZ5,
    SLKZ6,
    SLKZ7,
    SLKZ8,
    VRKZ1,
    VRKZ2,
    VRKZ3,
    MTART,
    MEINS,
    DISST,
    BESKZ,
    SOBSL,
    SOBES,
    WRK02,
    DISMM,
    DISVF,
    DISPO,
    PLDIS,
    EKGRP,
    MTWZT,
    WEBAZ,
    BEAZT,
    FIXTR,
    MFHKZ,
    DISLS,
    LOSVF,
    LOSKZ,
    PERAZ,
    EISBE,
    MINBE,
    HOEBE,
    BSTMI,
    BSTMA,
    BSTFX,
    BSTRF,
    SUM01,
    SUM02,
    SUM03,
    SUM04,
    SUM05,
    NEGBS,
    MSGID,
    MSGAR,
    MSGNR,
    MSGV1,
    MSGV2,
    MSGV3,
    MSGV4,
    DISGR,
    PERIV,
    MRPPP,
    BDARF,
    LFRHY,
    RDPRF,
    BERW1,
    BERW2,
    KZAUS,
    AUSDT,
    NFMAT,
    AUSZ1,
    AUSZ2,
    AUSZ3,
    AUSZ4,
    AUSZ5,
    AUSZ6,
    AUSZ7,
    AUSZ8,
    BEADA,
    NAUKZ,
    SAUFT,
    KZPROMO,
    SHFLG,
    SHZET,
    FABKZ,
    MFXDT,
    BSKFL,
    MAABC,
    CFLAG,
    GRREL,
    RWPRO,
    SHPRO,
    AHDIS,
    BERW4,
    BADON,
    SGT_STATC,
    HANAON,
    GLCHANGETIME,
    ZHDCLTIMESTAMP;

[MDKP]:
SELECT "HVR_ROWID",
	"SHSTOVAR_SYNC_TIMESTAMP",
	"MANDT",
	"DTART",
	"MATNR",
	"PLWRK",
	"PLSCN",
	"DTNUM",
	"DSDAT",
	"BDBKZ",
	"SLKZ1",
	"SLKZ2",
	"SLKZ3",
	"SLKZ4",
	"SLKZ5",
	"SLKZ6",
	"SLKZ7",
	"SLKZ8",
	"VRKZ1",
	"VRKZ2",
	"VRKZ3",
	"MTART",
	"MEINS",
	"DISST",
	"BESKZ",
	"SOBSL",
	"SOBES",
	"WRK02",
	"DISMM",
	"DISVF",
	"DISPO",
	"PLDIS",
	"EKGRP",
	"MTWZT",
	"WEBAZ",
	"BEAZT",
	"FIXTR",
	"MFHKZ",
	"DISLS",
	"LOSVF",
	"LOSKZ",
	"PERAZ",
	"EISBE",
	"MINBE",
	"HOEBE",
	"BSTMI",
	"BSTMA",
	"BSTFX",
	"BSTRF",
	"SUM01",
	"SUM02",
	"SUM03",
	"SUM04",
	"SUM05",
	"NEGBS",
	"MSGID",
	"MSGAR",
	"MSGNR",
	"MSGV1",
	"MSGV2",
	"MSGV3",
	"MSGV4",
	"DISGR",
	"PERIV",
	"MRPPP",
	"BDARF",
	"LFRHY",
	"RDPRF",
	"BERW1",
	"BERW2",
	"KZAUS",
	"AUSDT",
	"NFMAT",
	"AUSZ1",
	"AUSZ2",
	"AUSZ3",
	"AUSZ4",
	"AUSZ5",
	"AUSZ6",
	"AUSZ7",
	"AUSZ8",
	"BEADA",
	"NAUKZ",
	"SAUFT",
	"KZPROMO",
	"SHFLG",
	"SHZET",
	"FABKZ",
	"MFXDT",
	"BSKFL",
	"MAABC",
	"CFLAG",
	"GRREL",
	"RWPRO",
	"SHPRO",
	"AHDIS",
	"BERW4",
	"BADON",
	"SGT_STATC",
	"HANAON",
	"GLCHANGETIME",
	"ZHDCLTIMESTAMP"
FROM "SCO_PRD"."RAW_SAP"."MDKP"

WHERE "PLWRK" IN ('0600', '0602', '5440', '5442', '4980', '3930', '544E');


MDTB:

LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];

Left Join ([MDKP])
LOAD
    HVR_ROWID,
    SHSTOVAR_SYNC_TIMESTAMP,
    MANDT,
    DTNUM,
    DTPOS,
    PLAKZ,
    PLANR,
    DAT00,
    SORT1,
    SORT2,
    DELKZ,
    VSTAT,
    VRFKZ,
    PLUMI,
    MNG01,
    MNG02,
    MNG03,
    DAT01,
    DAT02,
    DAT03,
    PERKZ,
    PRPER,
    WEBAZ,
    FIX01,
    FIX02,
    BAART,
    BESKZ,
    SOBES,
    UMSKZ,
    PLART,
    AUSSL,
    WRK02,
    LGORT,
    DELNR,
    DELPS,
    DELET,
    AUFVR,
    POSVR,
    EINVR,
    UKZ01,
    UMDAT,
    DEL12,
    BAUGR,
    DELVR,
    VERSB,
    OLDSL,
    RDMNG,
    PLAAB,
    TAG00,
    ABEKZ,
    MDFST,
    MDMNG,
    VERID,
    WRK01,
    SERNR,
    REVLV,
    DBSKZ,
    EXTNL,
    ADINF,
    RESLO,
    PRIO_URG,
    PRIO_REQ,
    MPNMT,
    GLCHANGETIME,
    ZHDCLTIMESTAMP;

[MDTB]:
SELECT "HVR_ROWID",
	"SHSTOVAR_SYNC_TIMESTAMP",
	"MANDT",
	"DTNUM",
	"DTPOS",
	"PLAKZ",
	"PLANR",
	"DAT00",
	"SORT1",
	"SORT2",
	"DELKZ",
	"VSTAT",
	"VRFKZ",
	"PLUMI",
	"MNG01",
	"MNG02",
	"MNG03",
	"DAT01",
	"DAT02",
	"DAT03",
	"PERKZ",
	"PRPER",
	"WEBAZ",
	"FIX01",
	"FIX02",
	"BAART",
	"BESKZ",
	"SOBES",
	"UMSKZ",
	"PLART",
	"AUSSL",
	"WRK02",
	"LGORT",
	"DELNR",
	"DELPS",
	"DELET",
	"AUFVR",
	"POSVR",
	"EINVR",
	"UKZ01",
	"UMDAT",
	"DEL12",
	"BAUGR",
	"DELVR",
	"VERSB",
	"OLDSL",
	"RDMNG",
	"PLAAB",
	"TAG00",
	"ABEKZ",
	"MDFST",
	"MDMNG",
	"VERID",
	"WRK01",
	"SERNR",
	"REVLV",
	"DBSKZ",
	"EXTNL",
	"ADINF",
	"RESLO",
	"PRIO_URG",
	"PRIO_REQ",
	"MPNMT",
	"GLCHANGETIME",
	"ZHDCLTIMESTAMP"
FROM "SCO_PRD"."RAW_SAP"."MDTB";